package com.fhao.lotterysystem.dao.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserMapper {
    /**
     * 根据邮箱查询人数
     * @param email 邮箱
     * @return 绑定该邮箱的人数
     */
    @Select("select count(*) from user where email = #{email}")
    int countByMail(@Param("email") String email);
}
